Quản lý nhân sự công ty bằng c# _ full source code
60.426 lượt xem;
- frmkiemtrabangluong.cs
- QuanLyNhanSu /
- project /
1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Text;
7 using System.Windows.Forms;
8 using System.Data.SqlClient;
9 using Telerik.Data;
10 using Telerik.WinControls.UI;
11 using QuanLyNhanSu.Class;
12 using Telerik.WinControls;
13
14 namespace QuanLyNhanSu
15 {
16 public partial class frmkiemtrabangluong : RadForm
17 {
18 //khai báo biến toàn cục
19 public SqlConnection sc = frmMain.me.sql.connectSQL();
20 public SqlDataAdapter sda = new SqlDataAdapter();
21 public DataSet ds = new DataSet();
22 clsbangluong cbangluong = new clsbangluong();
23 public static string thangkt, namkt;
24 public frmkiemtrabangluong()
25 {
26 InitializeComponent();
27 for (int i = 1; i <= 12; i++)
28 {
29 cbothangkt.Items.Add(i);
30 }
31 for (int i = 2008; i <= 2100; i++)
32 {
33 cbonamkt.Items.Add(i);
34 }
35 }
36
37 private bool kiemtra(string thang, string nam)
38 {
39 ds.Clear();
40 string sel = "select * from tbl_BangLuong where thang ='" + thang
41 + "' and nam ='" + nam + "'";
42 sc.Open();
43 SqlCommand scmd = new SqlCommand(sel, sc);
44 object o = scmd.ExecuteScalar();
45 sc.Close();
46 if (o != null)
47 return true ;
48 else
49 return false ;
50 }
51
52 private DataTable danhsachNVchamcong(string thang, string nam)
53 {
54 string kthd = "select distinct manv from tbl_chitiethopdong"+
55 " where ngayketthuc >='"+thang+"/01/"+nam+"'";
56 sc.Open();
57 SqlCommand scmd = new SqlCommand(kthd, sc);
58 sda.SelectCommand = scmd;
59 sda.Fill(ds,"NV_hopdong");
60 sc.Close();
61 return ds.Tables["NV_hopdong"];
62 }
63
64 private void cmdkiemtra_Click(object sender, EventArgs e)
65 {
66 thangkt = cbothangkt.Text.Trim();
67 namkt = cbonamkt.Text.Trim();
68 if(kiemtra(cbothangkt.Text.Trim(),cbonamkt.Text.Trim())== true)
69 {
70 frmbangluong f = new frmbangluong();
71 f.MdiParent = this.MdiParent;
72 f.Show();
73 Close();
74 }
75 else
76 {
77 DialogResult rs = MessageBox.Show("Không có dữ liệu bảng lương này!!! \n Bạn có muốn tạo bảng lương này", "Thông báo", MessageBoxButtons.YesNo);
78 if(rs == DialogResult.Yes )
79 {
80 DataTable dt = danhsachNVchamcong(cbothangkt.Text.Trim(),cbonamkt.Text.Trim());
81 for (int i = 0; i <= dt.Rows.Count - 1; i++)
82 {
83 cbangluong.them(dt.Rows[i]["manv"].ToString(), cbothangkt.Text.Trim(), cbonamkt.Text.Trim());
84 }
85 Close();
86 frmbangluong f = new frmbangluong();
87 f.MdiParent = this.MdiParent;
88 f.Show();
89 }
90
91 }
92 }
93
94 private void cmdthoat_Click(object sender, EventArgs e)
95 {
96 Close();
97 }
98 }
99 }
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Text;
7 using System.Windows.Forms;
8 using System.Data.SqlClient;
9 using Telerik.Data;
10 using Telerik.WinControls.UI;
11 using QuanLyNhanSu.Class;
12 using Telerik.WinControls;
13
14 namespace QuanLyNhanSu
15 {
16 public partial class frmkiemtrabangluong : RadForm
17 {
18 //khai báo biến toàn cục
19 public SqlConnection sc = frmMain.me.sql.connectSQL();
20 public SqlDataAdapter sda = new SqlDataAdapter();
21 public DataSet ds = new DataSet();
22 clsbangluong cbangluong = new clsbangluong();
23 public static string thangkt, namkt;
24 public frmkiemtrabangluong()
25 {
26 InitializeComponent();
27 for (int i = 1; i <= 12; i++)
28 {
29 cbothangkt.Items.Add(i);
30 }
31 for (int i = 2008; i <= 2100; i++)
32 {
33 cbonamkt.Items.Add(i);
34 }
35 }
36
37 private bool kiemtra(string thang, string nam)
38 {
39 ds.Clear();
40 string sel = "select * from tbl_BangLuong where thang ='" + thang
41 + "' and nam ='" + nam + "'";
42 sc.Open();
43 SqlCommand scmd = new SqlCommand(sel, sc);
44 object o = scmd.ExecuteScalar();
45 sc.Close();
46 if (o != null)
47 return true ;
48 else
49 return false ;
50 }
51
52 private DataTable danhsachNVchamcong(string thang, string nam)
53 {
54 string kthd = "select distinct manv from tbl_chitiethopdong"+
55 " where ngayketthuc >='"+thang+"/01/"+nam+"'";
56 sc.Open();
57 SqlCommand scmd = new SqlCommand(kthd, sc);
58 sda.SelectCommand = scmd;
59 sda.Fill(ds,"NV_hopdong");
60 sc.Close();
61 return ds.Tables["NV_hopdong"];
62 }
63
64 private void cmdkiemtra_Click(object sender, EventArgs e)
65 {
66 thangkt = cbothangkt.Text.Trim();
67 namkt = cbonamkt.Text.Trim();
68 if(kiemtra(cbothangkt.Text.Trim(),cbonamkt.Text.Trim())== true)
69 {
70 frmbangluong f = new frmbangluong();
71 f.MdiParent = this.MdiParent;
72 f.Show();
73 Close();
74 }
75 else
76 {
77 DialogResult rs = MessageBox.Show("Không có dữ liệu bảng lương này!!! \n Bạn có muốn tạo bảng lương này", "Thông báo", MessageBoxButtons.YesNo);
78 if(rs == DialogResult.Yes )
79 {
80 DataTable dt = danhsachNVchamcong(cbothangkt.Text.Trim(),cbonamkt.Text.Trim());
81 for (int i = 0; i <= dt.Rows.Count - 1; i++)
82 {
83 cbangluong.them(dt.Rows[i]["manv"].ToString(), cbothangkt.Text.Trim(), cbonamkt.Text.Trim());
84 }
85 Close();
86 frmbangluong f = new frmbangluong();
87 f.MdiParent = this.MdiParent;
88 f.Show();
89 }
90
91 }
92 }
93
94 private void cmdthoat_Click(object sender, EventArgs e)
95 {
96 Close();
97 }
98 }
99 }